SUPPORT / SAMPLES & SAS NOTES
Problem Note 53980: The SZPF_GP_STATUS_DERIVATION_UNIT task might generate "ERROR: A lock is not available for DI_DM.PRF_GEO_PROD_STATUS_META.DATA"
 |  |  |  |  |
In SAS® Size Profiling, the SZPF_GP_STATUS_DERIVATION_UNIT task might fail with errors similar to the following in the SZPF_GP_STATUS_DERIVATION_UNIT log:
NOTE: CHG_LIB.PRF_GEO_PROD_STATUS.DATA is no longer locked by you. ERROR: A lock is not available for DI_DM.PRF_GEO_PROD_STATUS_META.DATA. ERROR: A lock is not available for DI_DM.PRF_GEO_PROD_STATUS_META.DATA. ERROR: Lock held by process XXXXX.
There is no workaround for this issue.
Contact SAS Technical Support if you encounter this problem to obtain a script to ensure that the DI_DM.PRF_GEO_PROD_STATUS_META table is in sync with data in PRF_GEO_PROD_STATUS.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M0 | ||
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M0 | ||